IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'RealmDescriptionGet')
	BEGIN
		DROP  Procedure  RealmDescriptionGet
	END

GO

CREATE Procedure RealmDescriptionGet
@RealmID int
AS
Select 
r.Description
From Realm r
Where r.RealmID = @RealmID


GO


